This model dimension represents condition codes and is based on the IFS Cloud dimension DIM_PURCHASE_CHARGE_TYPE. All models that refer to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
Charge | |
Charge Amount | Charge Amount |
Price UoM | Pricing Unit of Measure |
Purchase Charge Code | Represents the CODE of the dimension, i.e. the charge type code. |
Purchase Charge Descr | Represents the DESCRIPTION of a charge type. |
Purchase Charge Distributed by | The method of distributing the charge, i.e. per amount, per weight etc. Underlying column DISTRIBUTE_CHARGE_BY_DESC. |
Purchase Charge Group | Represents the charge group. |
Purchase Charge Site | The code of the site being charged. |
Purchase Charge Supplier | Charging Supplier Code if appicable |
Purchase Charge Type | Built as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION |
Hierarchy | Level |
PurchChargeGroupHy | |
Purchase Charge Group | |
Purchase Charge Type |
Model Name |
Procurement |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
PURCHASE CHARGE TYPE | DIM_PURCHASE_CHARGE_TYPE_BI | DIM_PURCHASE_CHARGE_TYPE_BI | DIM_PURCHASE_CHARGE_TYPE | On Line |